Owner

dbo

Creation Date

10-07-2003 10:31:35

Remarks

Columns

Name	Type	Length	IsNullable	Collation
ProductID	int	4
ProductName	nvarchar	80		SQL_Latin1_General_CP1_CI_AS
ProductName	sysname	80		SQL_Latin1_General_CP1_CI_AS
SupplierID	int	4
CategoryID	int	4
QuantityPerUnit	nvarchar	40		SQL_Latin1_General_CP1_CI_AS
QuantityPerUnit	sysname	40		SQL_Latin1_General_CP1_CI_AS
UnitPrice	money	8
UnitsInStock	smallint	2
UnitsOnOrder	smallint	2
ReorderLevel	smallint	2
Discontinued	bit	1
CategoryName	nvarchar	30		SQL_Latin1_General_CP1_CI_AS
CategoryName	sysname	30		SQL_Latin1_General_CP1_CI_AS

View Definition

create view "Alphabetical list of products" AS
SELECT Products.*, Categories.CategoryName
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
WHERE (((Products.Discontinued)=0))